package com.huatai.saas.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.huatai.saas.entity.AnnouncementEntity;
import com.huatai.saas.vo.AnnouncementVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * 公告类的数据持久层
 * @program: nanming-saas
 * @author: zcw
 * @create: 2024-04-24 14:00
 */
@Mapper
public interface AnnouncementMapper extends BaseMapper<AnnouncementEntity> {
	/**
	 * 查询公告列表
	 * @param page 分页信息
	 * @return
	 */
	@Select("SELECT id,title,content,update_time,create_time FROM announcement")
	IPage<AnnouncementVO> getAnnouncementList(Page<AnnouncementVO> page);
}
